OPTIONS(direct=true,silent=feedback)
LOAD DATA
CHARACTERSET UTF8
INTO TABLE stg_pos_service_usage_USA3
TRUNCATE
FIELDS TERMINATED BY X'09'
(date_id "substr(:date_id,1,4)||substr(:date_id,6,2)||substr(:date_id,9,2)",
hour,
serving_mcc,
serving_mnc,
mcc_country,
protocol_type,
model,
operator_id,
total_count)

